comparsionSql='''  '''

searchTallestSql = ''' SELECT * FROM 	( SELECT COUNT( 1 ), Number1 FROM WinningNumbers GROUP BY Number1 ORDER BY count( 1 ) DESC LIMIT 1 ) a UNION ALL
SELECT 	* FROM	( SELECT COUNT( 1 ), Number2 FROM WinningNumbers GROUP BY Number2 ORDER BY count( 1 ) DESC LIMIT 1 ) a UNION ALL
SELECT * FROM ( SELECT COUNT( 1 ), Number3 FROM WinningNumbers GROUP BY Number3 ORDER BY count( 1 ) DESC LIMIT 1 ) a UNION ALL
SELECT * FROM	( SELECT COUNT( 1 ), Number4 FROM WinningNumbers GROUP BY Number4 ORDER BY count( 1 ) DESC LIMIT 1 ) a UNION ALL
SELECT * FROM	( SELECT COUNT( 1 ), Number5 FROM WinningNumbers GROUP BY Number5 ORDER BY count( 1 ) DESC LIMIT 1 ) a UNION ALL
SELECT * FROM	( SELECT COUNT( 1 ), Number6 FROM WinningNumbers GROUP BY Number6 ORDER BY count( 1 ) DESC LIMIT 1 ) a UNION ALL
SELECT	* FROM	( SELECT COUNT( 1 ), Number7 FROM WinningNumbers GROUP BY Number7 ORDER BY count( 1 ) DESC LIMIT 1 ) a '''
searchLowSql=''' SELECT * FROM 	( SELECT COUNT( 1 ), Number1 FROM WinningNumbers GROUP BY Number1 ORDER BY count( 1 )  LIMIT 1 ) a UNION ALL
SELECT 	* FROM	( SELECT COUNT( 1 ), Number2 FROM WinningNumbers GROUP BY Number2 ORDER BY count( 1 )  LIMIT 1 ) a UNION ALL
SELECT * FROM ( SELECT COUNT( 1 ), Number3 FROM WinningNumbers GROUP BY Number3 ORDER BY count( 1 )  LIMIT 1 ) a UNION ALL
SELECT * FROM	( SELECT COUNT( 1 ), Number4 FROM WinningNumbers GROUP BY Number4 ORDER BY count( 1 )  LIMIT 1 ) a UNION ALL
SELECT * FROM	( SELECT COUNT( 1 ), Number5 FROM WinningNumbers GROUP BY Number5 ORDER BY count( 1 )  LIMIT 1 ) a UNION ALL
SELECT * FROM	( SELECT COUNT( 1 ), Number6 FROM WinningNumbers GROUP BY Number6 ORDER BY count( 1 )  LIMIT 1 ) a UNION ALL
SELECT	* FROM	( SELECT COUNT( 1 ), Number7 FROM WinningNumbers GROUP BY Number7 ORDER BY count( 1 )  LIMIT 1 ) a '''
searchTallRed=''' select b.n,sum(c) as c from (
select * from (select COUNT(1) AS c ,Number1 as n from WinningNumbers GROUP BY Number1 order by count(1) desc) as a 
UNION ALL
select * from (select COUNT(1) ,Number2 from WinningNumbers GROUP BY Number2 order by count(1) desc) as a
UNION ALL
select * from (select COUNT(1) ,Number3 from WinningNumbers GROUP BY Number3 order by count(1) desc) as a
UNION ALL
select * from (select COUNT(1) ,Number4 from WinningNumbers GROUP BY Number4 order by count(1) desc) as a
UNION ALL
select * from (select COUNT(1) ,Number5 from WinningNumbers GROUP BY Number5 order by count(1) desc) as a
UNION ALL
select * from (select COUNT(1) ,Number6 from WinningNumbers GROUP BY Number6 order by count(1) desc) as a
) as b GROUP BY b.n order by c desc LIMIT 6 '''
searhcLowRed=''' select b.n,sum(c) as c from (
select * from (select COUNT(1) AS c ,Number1 as n from WinningNumbers GROUP BY Number1 order by count(1) desc) as a 
UNION ALL
select * from (select COUNT(1) ,Number2 from WinningNumbers GROUP BY Number2 order by count(1) desc) as a
UNION ALL
select * from (select COUNT(1) ,Number3 from WinningNumbers GROUP BY Number3 order by count(1) desc) as a
UNION ALL
select * from (select COUNT(1) ,Number4 from WinningNumbers GROUP BY Number4 order by count(1) desc) as a
UNION ALL
select * from (select COUNT(1) ,Number5 from WinningNumbers GROUP BY Number5 order by count(1) desc) as a
UNION ALL
select * from (select COUNT(1) ,Number6 from WinningNumbers GROUP BY Number6 order by count(1) desc) as a
) as b GROUP BY b.n order by c LIMIT 6 '''